Skip to main content

Overview

In this section, you will find various notes covering multiple topics in Information Systems.

This section focuses primarily on Database Systems, which are essential components of modern information systems. It covers both theoretical foundations and practical implementation strategies.

Database Systems
Examines the internal structure and behavior of database systems, including how data is stored, indexed, queried, and optimized. Topics include:

  • File Organization – Different methods of organizing data on disk, including heap files, sorted files, and hashed storage.
  • Indexing – Techniques to improve query performance using indexes like B+ trees and hash-based indexes.
  • Query Processing – How queries are parsed, optimized, and executed internally by the database engine.
  • Schema Tuning – Strategies for designing and adjusting schema structures to improve performance and maintainability.
  • Transaction and Concurrency – Ensuring consistency and isolation in multi-user environments through transaction management and concurrency control.